<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>Add grand totals</title>
    <link rel="StyleSheet" href="css/crosstab.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ct-TutT5AddACrossTabToTheReport.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="ct-HowToFilterDataAtTheCrossTabLevel.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h3 class="N_TutorialTask">Task 6:&nbsp;&nbsp;<a name="521417">Add grand totals</a></h3>
      <p class="b_Body"><a name="521420">Each number displayed in the cross tab represents the sales total of a particular product for a particular state. In this procedure, </a>you add grand totals to display the total sales of all products for each state, the total sales of each product, and the total of all sales across products and states.</p>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222149">Choose Layout to resume editing the cross tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="408414">Select the cross tab, if necessary, by clicking on the tab in the lower left corner of the cross tab. Make sure you select the entire cross tab, not just a part of it. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222153">In Property Editor, choose the Row Area tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222154">Choose Grand Totals, then choose Add.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="341399">In Grand Total, shown in </a><a href="#341405" title="Add grand totals">Figure&nbsp;16-11</a>, use the default values, then choose OK.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="341403"><img class="Default" src="images/xtab_rowtotal.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-11 Creating grand totals in the cross-tab row area" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-11&nbsp;&nbsp;</b><a name="341405">Creating grand totals in the cross-tab row area</a></div>
      <div class="N_i_Indent1"><a name="341384">A new row is added to the bottom of the cross tab, as shown in </a><a href="#341393" title="Add grand totals">Figure&nbsp;16-12</a>. In this row is a label that displays Grand Total and a data element that displays <img class="Default" src="images/crosstab.16.8.2.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="" />[EXTENDED_PRICE].</div>
      <p class="i2_Image2"><a name="341391"><img class="Default" src="images/xtab_layout3.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-12 Cross tab including a new row to display grand totals" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-12&nbsp;&nbsp;</b><a name="341393">Cross tab including a new row to display grand totals</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">6&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222202">In Property Editor, choose the Column Area tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">7&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222208">Choose Grand Totals, then choose Add.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">8&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222212">In Grand Total, use the default values, then choose OK. A new column is added to the cross tab, as shown in </a><a href="#311715" title="Add grand totals">Figure&nbsp;16-13</a>. </div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="311713"><img class="Default" src="images/xtab_layout4.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-13 Cross tab with a new column to display grand totals" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-13&nbsp;&nbsp;</b><a name="311715">Cross tab with a new column to display grand totals</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">9&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="222242">Preview the report. Grand totals appear in the last row and last column of the cross tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>